package com.dhsc.local.dao.impl.yykh;

import com.dhsc.domain.ywzx.yykh.XjgyLsVo;
import com.dhsc.domain.ywzx.yykh.XjgypdVo;
import com.dhsc.domain.ywzx.yykh.XjgytssxVo;
import com.dhsc.local.dao.yykh.IXjgypdDao;
import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @ClassName: XjgypdDaoImpl
 * @Description: 星级柜员判定
 * @date: 2023/11/29 11:24
 * @author: jwj
 */
@Repository("xjgypddao")
public class XjgypdDaoImpl implements IXjgypdDao {

	@Autowired
	private SqlSessionTemplate localSqlSessionTemplate;

    @Autowired
    private SqlSessionTemplate viewSqlSessionTemplate;


    @Override
    public List<XjgypdVo> queryZbXjgypdInfo() {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryZbXjgypdInfo");
    }

    @Override
    public List<XjgypdVo> queryXjgypdInfo(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryXjgypdInfo",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryYwslLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryYwslLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryYwzlLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryYwzlLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryYwxlLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryYwxlLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryKhpjLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryKhpjLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryPxksLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryPxksLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryYwjsLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryYwjsLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryJyxcLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryJyxcLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryJxclLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryJxclLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryZgclLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryZgclLs",xjgypdVo);
    }

    @Override
    public String querySyrjyr(String dateSystem) {
        return viewSqlSessionTemplate.selectOne("SjcjMapper.querySyrjyr",dateSystem);
    }

    @Override
    public List<XjgytssxVo> queryXjgytssxInfo(XjgytssxVo xjgytssxVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryXjgytssxInfo",xjgytssxVo);
    }

    @Override
    public List<XjgytssxVo> queryTssxGyxl() {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryTssxGyxl");
    }

    @Override
    public int deleteXjgytssx(Integer bh) {
        return localSqlSessionTemplate.delete("XjgypdMapper.deleteXjgytssx",bh);
    }

    @Override
    public int queryExistTssx(XjgytssxVo xjgytssxVo) {
        return localSqlSessionTemplate.selectOne("XjgypdMapper.queryExistTssx",xjgytssxVo);
    }

    @Override
    public int insertXjgytssx(XjgytssxVo xjgytssxVo) {
        return localSqlSessionTemplate.insert("XjgypdMapper.insertXjgytssx",xjgytssxVo);
    }

    @Override
    public List<XjgyLsVo> queryMydDfLs(XjgypdVo xjgypdVo) {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryMydDfLs",xjgypdVo);
    }

    @Override
    public List<XjgyLsVo> queryYwmc() {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryYwmc");
    }

    @Override
    public List<XjgyLsVo> queryFqqdmc() {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryFqqdmc");
    }

    @Override
    public List<XjgyLsVo> queryClztmc() {
        return localSqlSessionTemplate.selectList("XjgypdMapper.queryClztmc");
    }

    @Override
    public List<XjgyLsVo> querySfpjmc() {
        return localSqlSessionTemplate.selectList("XjgypdMapper.querySfpjmc");
    }
}
